package com.bosch.in.rtp1.ept.constant;

/**
 * Define constant for column name of LotStatus table
 * @author TPR1HC
 *
 */
public interface LotStatusColumnName {
	String LOT_ID = "Lotid";
	String CURMAIN_QTY = "QTY";
	String PART_ID = "Partid";
	String LOT_TYPE = "LTyp";
	String CUSTOMER_NAME = "Customername";
	String PRIORITY = "Prio";
	String STATE = "State";
	String WAIT_TIME = "Wartezeit /d";
	String X_PLAN = "X-PLAN";
	String X_RW = "X-RW";
	String X_RWH = "X-RWH";
	String LOT_COMMENT = "Lotcomment";
	String HOLD_CODE = "HCode";
	String HOLD_REASON = "Holdreason";
	String PRO_AREA = "Area";
	String LOCATION = "LOC";
	String CUR_PRCD_ID = "Curprcdid";
	String STAGE = "Stage";
	String RECIPE_ID = "Recpid";
	String RECIPE_TITLE = "Recipe-Title";
	String EQP_TYPE = "EqpType";
	String EQUIP_ID = "EqpID";
	String QUEUE_TIME = "Queuetime";
	String START_TIME = "Starttime";
	String CR1_SAP = "CR1 - SAP";
	
	String MEMS_LOT_STATUS_TITLE = "MEMS LOT STATUS";
	
	String LOT_ID_DB = "LOTID";
	String CURMAIN_QTY_DB = "CURMAINQTY";
	String PART_ID_DB = "PARTID";
	String LOT_TYPE_DB = "LOTTYPE";
	String CUSTOMER_NAME_DB = "CUSTOMERNAME";
	String PRIORITY_DB = "PRIORITY";
	String STATE_DB = "STATE";
	String LOT_COMMENT_DB = "LOTCMNT";
	String HOLD_CODE_DB = "HOLDCODE";
	String HOLD_REASON_DB = "HOLDREAS";
	String PRO_AREA_DB = "PRODAREA";
	String LOCATION_DB = "LOCATION";
	String CUR_PRCD_ID_DB = "CURPRCDID";
	String STAGE_DB = "STAGE";
	String RECIPE_ID_DB = "RECPID";
	String RECIPE_TITLE_DB = "P1R_RECIPE_TITLE";
	String EQP_TYPE_DB = "EQPTYPE";
	String EQUIP_ID_DB = "EQPID";
	String QUEUE_TIME_DB = "QUEUETIME";
	String START_TIME_DB = "STARTTIME";
	String CR1_SAP_DB = "CR1";
	/* this is actually not real field in database, it is calculated from other */
	String WAIT_TIME_DB = "WAITTIME";
	String X_PLAN_DB = "P1B_X_PLAN";
	String X_RW_DB = "P1B_X_RW";
	String X_RWH_DB = "P1B_X_RWH";
	
	
}